package com.tangdi.production.mpaychl.model;

import java.util.ArrayList;
import java.util.List;

public class MpomngPayInfExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MpomngPayInfExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPayordnoIsNull() {
            addCriterion("PAYORDNO is null");
            return (Criteria) this;
        }

        public Criteria andPayordnoIsNotNull() {
            addCriterion("PAYORDNO is not null");
            return (Criteria) this;
        }

        public Criteria andPayordnoEqualTo(String value) {
            addCriterion("PAYORDNO =", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoNotEqualTo(String value) {
            addCriterion("PAYORDNO <>", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoGreaterThan(String value) {
            addCriterion("PAYORDNO >", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoGreaterThanOrEqualTo(String value) {
            addCriterion("PAYORDNO >=", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoLessThan(String value) {
            addCriterion("PAYORDNO <", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoLessThanOrEqualTo(String value) {
            addCriterion("PAYORDNO <=", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoLike(String value) {
            addCriterion("PAYORDNO like", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoNotLike(String value) {
            addCriterion("PAYORDNO not like", value, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoIn(List<String> values) {
            addCriterion("PAYORDNO in", values, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoNotIn(List<String> values) {
            addCriterion("PAYORDNO not in", values, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoBetween(String value1, String value2) {
            addCriterion("PAYORDNO between", value1, value2, "payordno");
            return (Criteria) this;
        }

        public Criteria andPayordnoNotBetween(String value1, String value2) {
            addCriterion("PAYORDNO not between", value1, value2, "payordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoIsNull() {
            addCriterion("PRDORDNO is null");
            return (Criteria) this;
        }

        public Criteria andPrdordnoIsNotNull() {
            addCriterion("PRDORDNO is not null");
            return (Criteria) this;
        }

        public Criteria andPrdordnoEqualTo(String value) {
            addCriterion("PRDORDNO =", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoNotEqualTo(String value) {
            addCriterion("PRDORDNO <>", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoGreaterThan(String value) {
            addCriterion("PRDORDNO >", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoGreaterThanOrEqualTo(String value) {
            addCriterion("PRDORDNO >=", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoLessThan(String value) {
            addCriterion("PRDORDNO <", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoLessThanOrEqualTo(String value) {
            addCriterion("PRDORDNO <=", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoLike(String value) {
            addCriterion("PRDORDNO like", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoNotLike(String value) {
            addCriterion("PRDORDNO not like", value, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoIn(List<String> values) {
            addCriterion("PRDORDNO in", values, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoNotIn(List<String> values) {
            addCriterion("PRDORDNO not in", values, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoBetween(String value1, String value2) {
            addCriterion("PRDORDNO between", value1, value2, "prdordno");
            return (Criteria) this;
        }

        public Criteria andPrdordnoNotBetween(String value1, String value2) {
            addCriterion("PRDORDNO not between", value1, value2, "prdordno");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNull() {
            addCriterion("CUST_ID is null");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNotNull() {
            addCriterion("CUST_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCustIdEqualTo(String value) {
            addCriterion("CUST_ID =", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotEqualTo(String value) {
            addCriterion("CUST_ID <>", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThan(String value) {
            addCriterion("CUST_ID >", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThanOrEqualTo(String value) {
            addCriterion("CUST_ID >=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThan(String value) {
            addCriterion("CUST_ID <", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThanOrEqualTo(String value) {
            addCriterion("CUST_ID <=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLike(String value) {
            addCriterion("CUST_ID like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotLike(String value) {
            addCriterion("CUST_ID not like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdIn(List<String> values) {
            addCriterion("CUST_ID in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotIn(List<String> values) {
            addCriterion("CUST_ID not in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdBetween(String value1, String value2) {
            addCriterion("CUST_ID between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotBetween(String value1, String value2) {
            addCriterion("CUST_ID not between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNull() {
            addCriterion("PAYSTATUS is null");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNotNull() {
            addCriterion("PAYSTATUS is not null");
            return (Criteria) this;
        }

        public Criteria andPaystatusEqualTo(String value) {
            addCriterion("PAYSTATUS =", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotEqualTo(String value) {
            addCriterion("PAYSTATUS <>", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThan(String value) {
            addCriterion("PAYSTATUS >", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThanOrEqualTo(String value) {
            addCriterion("PAYSTATUS >=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThan(String value) {
            addCriterion("PAYSTATUS <", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThanOrEqualTo(String value) {
            addCriterion("PAYSTATUS <=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLike(String value) {
            addCriterion("PAYSTATUS like", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotLike(String value) {
            addCriterion("PAYSTATUS not like", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusIn(List<String> values) {
            addCriterion("PAYSTATUS in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotIn(List<String> values) {
            addCriterion("PAYSTATUS not in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusBetween(String value1, String value2) {
            addCriterion("PAYSTATUS between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotBetween(String value1, String value2) {
            addCriterion("PAYSTATUS not between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPayordtypeIsNull() {
            addCriterion("PAYORDTYPE is null");
            return (Criteria) this;
        }

        public Criteria andPayordtypeIsNotNull() {
            addCriterion("PAYORDTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPayordtypeEqualTo(String value) {
            addCriterion("PAYORDTYPE =", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeNotEqualTo(String value) {
            addCriterion("PAYORDTYPE <>", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeGreaterThan(String value) {
            addCriterion("PAYORDTYPE >", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYORDTYPE >=", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeLessThan(String value) {
            addCriterion("PAYORDTYPE <", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeLessThanOrEqualTo(String value) {
            addCriterion("PAYORDTYPE <=", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeLike(String value) {
            addCriterion("PAYORDTYPE like", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeNotLike(String value) {
            addCriterion("PAYORDTYPE not like", value, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeIn(List<String> values) {
            addCriterion("PAYORDTYPE in", values, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeNotIn(List<String> values) {
            addCriterion("PAYORDTYPE not in", values, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeBetween(String value1, String value2) {
            addCriterion("PAYORDTYPE between", value1, value2, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPayordtypeNotBetween(String value1, String value2) {
            addCriterion("PAYORDTYPE not between", value1, value2, "payordtype");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNull() {
            addCriterion("PAYTYPE is null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNotNull() {
            addCriterion("PAYTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPaytypeEqualTo(String value) {
            addCriterion("PAYTYPE =", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotEqualTo(String value) {
            addCriterion("PAYTYPE <>", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThan(String value) {
            addCriterion("PAYTYPE >", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYTYPE >=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThan(String value) {
            addCriterion("PAYTYPE <", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThanOrEqualTo(String value) {
            addCriterion("PAYTYPE <=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLike(String value) {
            addCriterion("PAYTYPE like", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotLike(String value) {
            addCriterion("PAYTYPE not like", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeIn(List<String> values) {
            addCriterion("PAYTYPE in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotIn(List<String> values) {
            addCriterion("PAYTYPE not in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeBetween(String value1, String value2) {
            addCriterion("PAYTYPE between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotBetween(String value1, String value2) {
            addCriterion("PAYTYPE not between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeIsNull() {
            addCriterion("PAYBIZTYPE is null");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeIsNotNull() {
            addCriterion("PAYBIZTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeEqualTo(String value) {
            addCriterion("PAYBIZTYPE =", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeNotEqualTo(String value) {
            addCriterion("PAYBIZTYPE <>", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeGreaterThan(String value) {
            addCriterion("PAYBIZTYPE >", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYBIZTYPE >=", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeLessThan(String value) {
            addCriterion("PAYBIZTYPE <", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeLessThanOrEqualTo(String value) {
            addCriterion("PAYBIZTYPE <=", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeLike(String value) {
            addCriterion("PAYBIZTYPE like", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeNotLike(String value) {
            addCriterion("PAYBIZTYPE not like", value, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeIn(List<String> values) {
            addCriterion("PAYBIZTYPE in", values, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeNotIn(List<String> values) {
            addCriterion("PAYBIZTYPE not in", values, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeBetween(String value1, String value2) {
            addCriterion("PAYBIZTYPE between", value1, value2, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andPaybiztypeNotBetween(String value1, String value2) {
            addCriterion("PAYBIZTYPE not between", value1, value2, "paybiztype");
            return (Criteria) this;
        }

        public Criteria andTerNoIsNull() {
            addCriterion("TER_NO is null");
            return (Criteria) this;
        }

        public Criteria andTerNoIsNotNull() {
            addCriterion("TER_NO is not null");
            return (Criteria) this;
        }

        public Criteria andTerNoEqualTo(String value) {
            addCriterion("TER_NO =", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoNotEqualTo(String value) {
            addCriterion("TER_NO <>", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoGreaterThan(String value) {
            addCriterion("TER_NO >", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoGreaterThanOrEqualTo(String value) {
            addCriterion("TER_NO >=", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoLessThan(String value) {
            addCriterion("TER_NO <", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoLessThanOrEqualTo(String value) {
            addCriterion("TER_NO <=", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoLike(String value) {
            addCriterion("TER_NO like", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoNotLike(String value) {
            addCriterion("TER_NO not like", value, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoIn(List<String> values) {
            addCriterion("TER_NO in", values, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoNotIn(List<String> values) {
            addCriterion("TER_NO not in", values, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoBetween(String value1, String value2) {
            addCriterion("TER_NO between", value1, value2, "terNo");
            return (Criteria) this;
        }

        public Criteria andTerNoNotBetween(String value1, String value2) {
            addCriterion("TER_NO not between", value1, value2, "terNo");
            return (Criteria) this;
        }

        public Criteria andTxamtIsNull() {
            addCriterion("TXAMT is null");
            return (Criteria) this;
        }

        public Criteria andTxamtIsNotNull() {
            addCriterion("TXAMT is not null");
            return (Criteria) this;
        }

        public Criteria andTxamtEqualTo(String value) {
            addCriterion("TXAMT =", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtNotEqualTo(String value) {
            addCriterion("TXAMT <>", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtGreaterThan(String value) {
            addCriterion("TXAMT >", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtGreaterThanOrEqualTo(String value) {
            addCriterion("TXAMT >=", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtLessThan(String value) {
            addCriterion("TXAMT <", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtLessThanOrEqualTo(String value) {
            addCriterion("TXAMT <=", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtLike(String value) {
            addCriterion("TXAMT like", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtNotLike(String value) {
            addCriterion("TXAMT not like", value, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtIn(List<String> values) {
            addCriterion("TXAMT in", values, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtNotIn(List<String> values) {
            addCriterion("TXAMT not in", values, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtBetween(String value1, String value2) {
            addCriterion("TXAMT between", value1, value2, "txamt");
            return (Criteria) this;
        }

        public Criteria andTxamtNotBetween(String value1, String value2) {
            addCriterion("TXAMT not between", value1, value2, "txamt");
            return (Criteria) this;
        }

        public Criteria andRateIsNull() {
            addCriterion("RATE is null");
            return (Criteria) this;
        }

        public Criteria andRateIsNotNull() {
            addCriterion("RATE is not null");
            return (Criteria) this;
        }

        public Criteria andRateEqualTo(String value) {
            addCriterion("RATE =", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotEqualTo(String value) {
            addCriterion("RATE <>", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThan(String value) {
            addCriterion("RATE >", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThanOrEqualTo(String value) {
            addCriterion("RATE >=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThan(String value) {
            addCriterion("RATE <", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThanOrEqualTo(String value) {
            addCriterion("RATE <=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLike(String value) {
            addCriterion("RATE like", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotLike(String value) {
            addCriterion("RATE not like", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateIn(List<String> values) {
            addCriterion("RATE in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotIn(List<String> values) {
            addCriterion("RATE not in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateBetween(String value1, String value2) {
            addCriterion("RATE between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotBetween(String value1, String value2) {
            addCriterion("RATE not between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andRateTypeIsNull() {
            addCriterion("RATE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andRateTypeIsNotNull() {
            addCriterion("RATE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRateTypeEqualTo(String value) {
            addCriterion("RATE_TYPE =", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeNotEqualTo(String value) {
            addCriterion("RATE_TYPE <>", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeGreaterThan(String value) {
            addCriterion("RATE_TYPE >", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_TYPE >=", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeLessThan(String value) {
            addCriterion("RATE_TYPE <", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeLessThanOrEqualTo(String value) {
            addCriterion("RATE_TYPE <=", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeLike(String value) {
            addCriterion("RATE_TYPE like", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeNotLike(String value) {
            addCriterion("RATE_TYPE not like", value, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeIn(List<String> values) {
            addCriterion("RATE_TYPE in", values, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeNotIn(List<String> values) {
            addCriterion("RATE_TYPE not in", values, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeBetween(String value1, String value2) {
            addCriterion("RATE_TYPE between", value1, value2, "rateType");
            return (Criteria) this;
        }

        public Criteria andRateTypeNotBetween(String value1, String value2) {
            addCriterion("RATE_TYPE not between", value1, value2, "rateType");
            return (Criteria) this;
        }

        public Criteria andFeeIsNull() {
            addCriterion("FEE is null");
            return (Criteria) this;
        }

        public Criteria andFeeIsNotNull() {
            addCriterion("FEE is not null");
            return (Criteria) this;
        }

        public Criteria andFeeEqualTo(String value) {
            addCriterion("FEE =", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotEqualTo(String value) {
            addCriterion("FEE <>", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThan(String value) {
            addCriterion("FEE >", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThanOrEqualTo(String value) {
            addCriterion("FEE >=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThan(String value) {
            addCriterion("FEE <", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThanOrEqualTo(String value) {
            addCriterion("FEE <=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLike(String value) {
            addCriterion("FEE like", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotLike(String value) {
            addCriterion("FEE not like", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeIn(List<String> values) {
            addCriterion("FEE in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotIn(List<String> values) {
            addCriterion("FEE not in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeBetween(String value1, String value2) {
            addCriterion("FEE between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotBetween(String value1, String value2) {
            addCriterion("FEE not between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andNetrecamtIsNull() {
            addCriterion("NETRECAMT is null");
            return (Criteria) this;
        }

        public Criteria andNetrecamtIsNotNull() {
            addCriterion("NETRECAMT is not null");
            return (Criteria) this;
        }

        public Criteria andNetrecamtEqualTo(String value) {
            addCriterion("NETRECAMT =", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtNotEqualTo(String value) {
            addCriterion("NETRECAMT <>", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtGreaterThan(String value) {
            addCriterion("NETRECAMT >", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtGreaterThanOrEqualTo(String value) {
            addCriterion("NETRECAMT >=", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtLessThan(String value) {
            addCriterion("NETRECAMT <", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtLessThanOrEqualTo(String value) {
            addCriterion("NETRECAMT <=", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtLike(String value) {
            addCriterion("NETRECAMT like", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtNotLike(String value) {
            addCriterion("NETRECAMT not like", value, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtIn(List<String> values) {
            addCriterion("NETRECAMT in", values, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtNotIn(List<String> values) {
            addCriterion("NETRECAMT not in", values, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtBetween(String value1, String value2) {
            addCriterion("NETRECAMT between", value1, value2, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andNetrecamtNotBetween(String value1, String value2) {
            addCriterion("NETRECAMT not between", value1, value2, "netrecamt");
            return (Criteria) this;
        }

        public Criteria andPayChannelIsNull() {
            addCriterion("PAY_CHANNEL is null");
            return (Criteria) this;
        }

        public Criteria andPayChannelIsNotNull() {
            addCriterion("PAY_CHANNEL is not null");
            return (Criteria) this;
        }

        public Criteria andPayChannelEqualTo(String value) {
            addCriterion("PAY_CHANNEL =", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotEqualTo(String value) {
            addCriterion("PAY_CHANNEL <>", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelGreaterThan(String value) {
            addCriterion("PAY_CHANNEL >", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_CHANNEL >=", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelLessThan(String value) {
            addCriterion("PAY_CHANNEL <", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelLessThanOrEqualTo(String value) {
            addCriterion("PAY_CHANNEL <=", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelLike(String value) {
            addCriterion("PAY_CHANNEL like", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotLike(String value) {
            addCriterion("PAY_CHANNEL not like", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelIn(List<String> values) {
            addCriterion("PAY_CHANNEL in", values, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotIn(List<String> values) {
            addCriterion("PAY_CHANNEL not in", values, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelBetween(String value1, String value2) {
            addCriterion("PAY_CHANNEL between", value1, value2, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotBetween(String value1, String value2) {
            addCriterion("PAY_CHANNEL not between", value1, value2, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayCardnoIsNull() {
            addCriterion("PAY_CARDNO is null");
            return (Criteria) this;
        }

        public Criteria andPayCardnoIsNotNull() {
            addCriterion("PAY_CARDNO is not null");
            return (Criteria) this;
        }

        public Criteria andPayCardnoEqualTo(String value) {
            addCriterion("PAY_CARDNO =", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoNotEqualTo(String value) {
            addCriterion("PAY_CARDNO <>", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoGreaterThan(String value) {
            addCriterion("PAY_CARDNO >", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_CARDNO >=", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoLessThan(String value) {
            addCriterion("PAY_CARDNO <", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoLessThanOrEqualTo(String value) {
            addCriterion("PAY_CARDNO <=", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoLike(String value) {
            addCriterion("PAY_CARDNO like", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoNotLike(String value) {
            addCriterion("PAY_CARDNO not like", value, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoIn(List<String> values) {
            addCriterion("PAY_CARDNO in", values, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoNotIn(List<String> values) {
            addCriterion("PAY_CARDNO not in", values, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoBetween(String value1, String value2) {
            addCriterion("PAY_CARDNO between", value1, value2, "payCardno");
            return (Criteria) this;
        }

        public Criteria andPayCardnoNotBetween(String value1, String value2) {
            addCriterion("PAY_CARDNO not between", value1, value2, "payCardno");
            return (Criteria) this;
        }

        public Criteria andIssnamIsNull() {
            addCriterion("ISSNAM is null");
            return (Criteria) this;
        }

        public Criteria andIssnamIsNotNull() {
            addCriterion("ISSNAM is not null");
            return (Criteria) this;
        }

        public Criteria andIssnamEqualTo(String value) {
            addCriterion("ISSNAM =", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamNotEqualTo(String value) {
            addCriterion("ISSNAM <>", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamGreaterThan(String value) {
            addCriterion("ISSNAM >", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamGreaterThanOrEqualTo(String value) {
            addCriterion("ISSNAM >=", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamLessThan(String value) {
            addCriterion("ISSNAM <", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamLessThanOrEqualTo(String value) {
            addCriterion("ISSNAM <=", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamLike(String value) {
            addCriterion("ISSNAM like", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamNotLike(String value) {
            addCriterion("ISSNAM not like", value, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamIn(List<String> values) {
            addCriterion("ISSNAM in", values, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamNotIn(List<String> values) {
            addCriterion("ISSNAM not in", values, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamBetween(String value1, String value2) {
            addCriterion("ISSNAM between", value1, value2, "issnam");
            return (Criteria) this;
        }

        public Criteria andIssnamNotBetween(String value1, String value2) {
            addCriterion("ISSNAM not between", value1, value2, "issnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamIsNull() {
            addCriterion("CRDNAM is null");
            return (Criteria) this;
        }

        public Criteria andCrdnamIsNotNull() {
            addCriterion("CRDNAM is not null");
            return (Criteria) this;
        }

        public Criteria andCrdnamEqualTo(String value) {
            addCriterion("CRDNAM =", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamNotEqualTo(String value) {
            addCriterion("CRDNAM <>", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamGreaterThan(String value) {
            addCriterion("CRDNAM >", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamGreaterThanOrEqualTo(String value) {
            addCriterion("CRDNAM >=", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamLessThan(String value) {
            addCriterion("CRDNAM <", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamLessThanOrEqualTo(String value) {
            addCriterion("CRDNAM <=", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamLike(String value) {
            addCriterion("CRDNAM like", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamNotLike(String value) {
            addCriterion("CRDNAM not like", value, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamIn(List<String> values) {
            addCriterion("CRDNAM in", values, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamNotIn(List<String> values) {
            addCriterion("CRDNAM not in", values, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamBetween(String value1, String value2) {
            addCriterion("CRDNAM between", value1, value2, "crdnam");
            return (Criteria) this;
        }

        public Criteria andCrdnamNotBetween(String value1, String value2) {
            addCriterion("CRDNAM not between", value1, value2, "crdnam");
            return (Criteria) this;
        }

        public Criteria andPaySignPicIsNull() {
            addCriterion("PAY_SIGN_PIC is null");
            return (Criteria) this;
        }

        public Criteria andPaySignPicIsNotNull() {
            addCriterion("PAY_SIGN_PIC is not null");
            return (Criteria) this;
        }

        public Criteria andPaySignPicEqualTo(String value) {
            addCriterion("PAY_SIGN_PIC =", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicNotEqualTo(String value) {
            addCriterion("PAY_SIGN_PIC <>", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicGreaterThan(String value) {
            addCriterion("PAY_SIGN_PIC >", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_SIGN_PIC >=", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicLessThan(String value) {
            addCriterion("PAY_SIGN_PIC <", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicLessThanOrEqualTo(String value) {
            addCriterion("PAY_SIGN_PIC <=", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicLike(String value) {
            addCriterion("PAY_SIGN_PIC like", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicNotLike(String value) {
            addCriterion("PAY_SIGN_PIC not like", value, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicIn(List<String> values) {
            addCriterion("PAY_SIGN_PIC in", values, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicNotIn(List<String> values) {
            addCriterion("PAY_SIGN_PIC not in", values, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicBetween(String value1, String value2) {
            addCriterion("PAY_SIGN_PIC between", value1, value2, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPaySignPicNotBetween(String value1, String value2) {
            addCriterion("PAY_SIGN_PIC not between", value1, value2, "paySignPic");
            return (Criteria) this;
        }

        public Criteria andPayDateIsNull() {
            addCriterion("PAY_DATE is null");
            return (Criteria) this;
        }

        public Criteria andPayDateIsNotNull() {
            addCriterion("PAY_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andPayDateEqualTo(String value) {
            addCriterion("PAY_DATE =", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateNotEqualTo(String value) {
            addCriterion("PAY_DATE <>", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateGreaterThan(String value) {
            addCriterion("PAY_DATE >", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_DATE >=", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateLessThan(String value) {
            addCriterion("PAY_DATE <", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateLessThanOrEqualTo(String value) {
            addCriterion("PAY_DATE <=", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateLike(String value) {
            addCriterion("PAY_DATE like", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateNotLike(String value) {
            addCriterion("PAY_DATE not like", value, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateIn(List<String> values) {
            addCriterion("PAY_DATE in", values, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateNotIn(List<String> values) {
            addCriterion("PAY_DATE not in", values, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateBetween(String value1, String value2) {
            addCriterion("PAY_DATE between", value1, value2, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayDateNotBetween(String value1, String value2) {
            addCriterion("PAY_DATE not between", value1, value2, "payDate");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("PAY_TIME is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("PAY_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(String value) {
            addCriterion("PAY_TIME =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(String value) {
            addCriterion("PAY_TIME <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(String value) {
            addCriterion("PAY_TIME >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_TIME >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(String value) {
            addCriterion("PAY_TIME <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(String value) {
            addCriterion("PAY_TIME <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLike(String value) {
            addCriterion("PAY_TIME like", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotLike(String value) {
            addCriterion("PAY_TIME not like", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<String> values) {
            addCriterion("PAY_TIME in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<String> values) {
            addCriterion("PAY_TIME not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(String value1, String value2) {
            addCriterion("PAY_TIME between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(String value1, String value2) {
            addCriterion("PAY_TIME not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeIsNull() {
            addCriterion("PAYORDTIME is null");
            return (Criteria) this;
        }

        public Criteria andPayordtimeIsNotNull() {
            addCriterion("PAYORDTIME is not null");
            return (Criteria) this;
        }

        public Criteria andPayordtimeEqualTo(String value) {
            addCriterion("PAYORDTIME =", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeNotEqualTo(String value) {
            addCriterion("PAYORDTIME <>", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeGreaterThan(String value) {
            addCriterion("PAYORDTIME >", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYORDTIME >=", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeLessThan(String value) {
            addCriterion("PAYORDTIME <", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeLessThanOrEqualTo(String value) {
            addCriterion("PAYORDTIME <=", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeLike(String value) {
            addCriterion("PAYORDTIME like", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeNotLike(String value) {
            addCriterion("PAYORDTIME not like", value, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeIn(List<String> values) {
            addCriterion("PAYORDTIME in", values, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeNotIn(List<String> values) {
            addCriterion("PAYORDTIME not in", values, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeBetween(String value1, String value2) {
            addCriterion("PAYORDTIME between", value1, value2, "payordtime");
            return (Criteria) this;
        }

        public Criteria andPayordtimeNotBetween(String value1, String value2) {
            addCriterion("PAYORDTIME not between", value1, value2, "payordtime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNull() {
            addCriterion("MODIFY_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNotNull() {
            addCriterion("MODIFY_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeEqualTo(String value) {
            addCriterion("MODIFY_TIME =", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotEqualTo(String value) {
            addCriterion("MODIFY_TIME <>", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThan(String value) {
            addCriterion("MODIFY_TIME >", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualTo(String value) {
            addCriterion("MODIFY_TIME >=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThan(String value) {
            addCriterion("MODIFY_TIME <", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThanOrEqualTo(String value) {
            addCriterion("MODIFY_TIME <=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLike(String value) {
            addCriterion("MODIFY_TIME like", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotLike(String value) {
            addCriterion("MODIFY_TIME not like", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIn(List<String> values) {
            addCriterion("MODIFY_TIME in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotIn(List<String> values) {
            addCriterion("MODIFY_TIME not in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeBetween(String value1, String value2) {
            addCriterion("MODIFY_TIME between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotBetween(String value1, String value2) {
            addCriterion("MODIFY_TIME not between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andCheckStatusIsNull() {
            addCriterion("CHECK_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andCheckStatusIsNotNull() {
            addCriterion("CHECK_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andCheckStatusEqualTo(String value) {
            addCriterion("CHECK_STATUS =", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusNotEqualTo(String value) {
            addCriterion("CHECK_STATUS <>", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusGreaterThan(String value) {
            addCriterion("CHECK_STATUS >", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusGreaterThanOrEqualTo(String value) {
            addCriterion("CHECK_STATUS >=", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusLessThan(String value) {
            addCriterion("CHECK_STATUS <", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusLessThanOrEqualTo(String value) {
            addCriterion("CHECK_STATUS <=", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusLike(String value) {
            addCriterion("CHECK_STATUS like", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusNotLike(String value) {
            addCriterion("CHECK_STATUS not like", value, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusIn(List<String> values) {
            addCriterion("CHECK_STATUS in", values, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusNotIn(List<String> values) {
            addCriterion("CHECK_STATUS not in", values, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusBetween(String value1, String value2) {
            addCriterion("CHECK_STATUS between", value1, value2, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andCheckStatusNotBetween(String value1, String value2) {
            addCriterion("CHECK_STATUS not between", value1, value2, "checkStatus");
            return (Criteria) this;
        }

        public Criteria andAgentIdIsNull() {
            addCriterion("AGENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andAgentIdIsNotNull() {
            addCriterion("AGENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAgentIdEqualTo(String value) {
            addCriterion("AGENT_ID =", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotEqualTo(String value) {
            addCriterion("AGENT_ID <>", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThan(String value) {
            addCriterion("AGENT_ID >", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_ID >=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThan(String value) {
            addCriterion("AGENT_ID <", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThanOrEqualTo(String value) {
            addCriterion("AGENT_ID <=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLike(String value) {
            addCriterion("AGENT_ID like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotLike(String value) {
            addCriterion("AGENT_ID not like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdIn(List<String> values) {
            addCriterion("AGENT_ID in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotIn(List<String> values) {
            addCriterion("AGENT_ID not in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdBetween(String value1, String value2) {
            addCriterion("AGENT_ID between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotBetween(String value1, String value2) {
            addCriterion("AGENT_ID not between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andReqJsonIsNull() {
            addCriterion("REQ_JSON is null");
            return (Criteria) this;
        }

        public Criteria andReqJsonIsNotNull() {
            addCriterion("REQ_JSON is not null");
            return (Criteria) this;
        }

        public Criteria andReqJsonEqualTo(String value) {
            addCriterion("REQ_JSON =", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonNotEqualTo(String value) {
            addCriterion("REQ_JSON <>", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonGreaterThan(String value) {
            addCriterion("REQ_JSON >", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonGreaterThanOrEqualTo(String value) {
            addCriterion("REQ_JSON >=", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonLessThan(String value) {
            addCriterion("REQ_JSON <", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonLessThanOrEqualTo(String value) {
            addCriterion("REQ_JSON <=", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonLike(String value) {
            addCriterion("REQ_JSON like", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonNotLike(String value) {
            addCriterion("REQ_JSON not like", value, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonIn(List<String> values) {
            addCriterion("REQ_JSON in", values, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonNotIn(List<String> values) {
            addCriterion("REQ_JSON not in", values, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonBetween(String value1, String value2) {
            addCriterion("REQ_JSON between", value1, value2, "reqJson");
            return (Criteria) this;
        }

        public Criteria andReqJsonNotBetween(String value1, String value2) {
            addCriterion("REQ_JSON not between", value1, value2, "reqJson");
            return (Criteria) this;
        }

        public Criteria andResJsonIsNull() {
            addCriterion("RES_JSON is null");
            return (Criteria) this;
        }

        public Criteria andResJsonIsNotNull() {
            addCriterion("RES_JSON is not null");
            return (Criteria) this;
        }

        public Criteria andResJsonEqualTo(String value) {
            addCriterion("RES_JSON =", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonNotEqualTo(String value) {
            addCriterion("RES_JSON <>", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonGreaterThan(String value) {
            addCriterion("RES_JSON >", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonGreaterThanOrEqualTo(String value) {
            addCriterion("RES_JSON >=", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonLessThan(String value) {
            addCriterion("RES_JSON <", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonLessThanOrEqualTo(String value) {
            addCriterion("RES_JSON <=", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonLike(String value) {
            addCriterion("RES_JSON like", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonNotLike(String value) {
            addCriterion("RES_JSON not like", value, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonIn(List<String> values) {
            addCriterion("RES_JSON in", values, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonNotIn(List<String> values) {
            addCriterion("RES_JSON not in", values, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonBetween(String value1, String value2) {
            addCriterion("RES_JSON between", value1, value2, "resJson");
            return (Criteria) this;
        }

        public Criteria andResJsonNotBetween(String value1, String value2) {
            addCriterion("RES_JSON not between", value1, value2, "resJson");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}